SELECT * FROM london_stages WHERE eventid IN (39310, 39334, 39338, 39342, 39348, 39351, 39355, 39368, 39374, 39376, 39377, 39385, 39387, 39392, 39393, 39395, 39396, 39401, 39410, 39412, 39414, 39416, 39418, 39420, 39422, 39427, 39428, 39429, 39431, 39432, 39434, 39437, 39441, 39927, 39928, 39932, 39934, 39943, 39945, 39950, 39952, 39955, 39956, 39960, 39961, 39962, 39963, 39964, 39965, 39966, 39967, 39968, 39969, 39970, 39972, 39976, 39978, 39981, 39983, 39985, 39990, 39992, 39994, 39996, 39998, 39999, 40001, 40002, 40003, 40004, 40007, 40009, 40010, 40011, 40013, 40014, 40018, 40022, 40028, 40035, 40036, 40041, 40043, 40045, 40047, 40049, 40050, 40053, 40054, 40056, 40058, 40060, 40062, 40067, 40068, 40097, 40153, 40162, 40207, 40242, 40247, 40251, 40278, 40291, 40296, 40307, 40315, 40319, 40361, 40383, 40386, 40395, 40400, 40407, 40417, 40424, 40430, 40449, 40457, 40458, 40465, 40472, 40473, 40476, 40478, 40479, 40481, 40484, 40487, 40489, 40491, 40494, 40502, 40505, 40507, 40515, 40520, 40526, 40530, 40535, 40536, 40538, 40540, 40543, 40546, 40547, 40548, 40549, 40550, 40551, 40552, 40554, 40555, 40556, 40558, 40559, 40560, 40561, 40562, 40573, 40583, 40588, 40607, 40614, 40617, 40621, 40623, 40635, 40637, 40643, 40657, 40659, 40662, 40664, 40722, 40731, 40735, 40737, 40740, 40742, 40764, 40766, 40774, 40780, 40791, 40800, 40820, 40824, 40827, 40841, 40847, 40861, 40879, 40881, 40888, 40893, 40901, 40909, 40914, 40916, 40924, 40932, 40937, 40971, 40979, 40982, 40984, 40988, 40996, 41001, 41003, 41006, 41008, 41015, 41019, 41020, 41023, 41026, 41027, 41031, 41033, 41035, 41036, 41039, 41049, 41053, 41058, 41062, 41065, 41069, 41073, 41074, 41075, 41076, 41078, 41079, 41080, 41081, 41084, 41086, 41089, 41090, 41091, 41092, 41093, 41094, 41095, 41096, 41097, 41104, 41106, 41108, 41110, 41112, 41113, 41116, 41118, 41129, 41142, 41149, 41151, 41161, 41164, 41168, 41173, 41178, 41193, 41202, 41204, 41208, 41212, 41214, 41216, 41232, 41237, 41240, 41242, 41254, 41263, 41265, 41280, 41282, 41284, 41286, 41289, 41296, 41303, 41308, 41310, 41312, 41314, 41317, 41319, 41324, 41328, 41334, 41343, 41346, 41351, 41353, 41363, 41368, 41378, 41384, 41387, 41389, 41393, 41396, 41398, 41403, 41411, 41440, 41446, 41457, 41464, 41465, 41470, 41475, 41490, 41497, 41502, 41504, 41507, 41509, 41514, 41517, 41519, 41522, 41526, 41528, 41531, 41533, 41536, 41538, 41544, 41548, 41553, 41563, 41568, 41579, 41580, 41585, 41586, 41589, 41592, 41594, 41597, 41600, 41603, 41606, 41609, 41610, 41612, 41615, 41616, 41618, 41620, 41621, 41623, 41626, 41630, 41631, 41634, 41635, 41636, 41637, 41638, 41640, 41641, 41642, 41643, 41648, 41649, 41651, 41664, 41667, 41673, 41675, 41676, 41677, 41679, 41683, 41702, 41706, 41710, 41713, 41722, 41724, 41728, 41730, 41732, 41734, 41736, 41738, 41740, 41744, 41754, 41756, 41758, 41760, 41762, 41764, 41767, 41771, 41773, 41775, 41778, 41780, 41794, 41796, 41799, 41801, 41803, 41806, 41808, 41813, 41815, 41817, 41820, 41822, 41825, 41832, 41835, 41837, 41840, 41842, 41845, 41847, 41850, 41857, 41862, 41867, 41871, 41886, 41892, 41902, 41905, 41915, 41917, 41922, 41925, 41928, 41930, 41933, 41940, 41944, 41953, 41957, 41960, 41962, 41970, 41973, 41975, 41979, 41983, 41986, 41989, 41993, 41997, 42000, 42002, 42013, 42016, 42020, 42036, 42049, 42060, 42062, 42065, 42067, 42075, 42077, 42082, 42085, 42087, 42095, 42097, 42102, 42105, 42113, 42116, 42118, 42121, 42123, 42128, 42133, 42143, 42149, 42164, 42165, 42166, 42275, 42277, 42279, 42281, 42284, 42286, 42290, 42295, 42298, 42305, 42309, 42311, 42313, 42315, 42319, 42321, 42323, 42331, 42339, 42349, 42353, 42358, 42361, 42363, 42366, 42388, 42391, 42402, 42407, 42411, 42414, 42416, 42424, 42426, 42429, 42436, 42449, 42451, 42454, 42457, 42460, 42464, 42471, 42474, 42478, 42488, 42490, 42493, 42500, 42503, 42507, 42512, 42514, 42516, 42517, 42529, 42555, 42560, 42575, 42580, 42615, 42624, 42632, 42641, 42648, 42673, 42676, 42681, 42683, 42686, 42696, 42701, 42706, 42711, 42716, 42718, 42720, 42727, 42730, 42734, 42742, 42744, 42746, 42854, 42859, 42875, 42892, 42897, 42905, 42915, 42923, 42931, 42943, 42945, 42955, 42957, 42964, 42967, 42978, 42996, 43000, 43009, 43028, 43033, 43035, 43039, 43047, 43049, 43053, 43061, 43073, 43076, 43085, 43094, 43103, 43105, 43109, 43112, 43114, 43119, 43121, 43126, 43133, 43140, 43147, 43162, 43166, 43169, 43171, 43179, 43185, 43197, 43199, 43216, 43231, 43236, 43241, 43267, 43282, 43287, 43292, 43294, 43307, 43309, 43314, 43319, 43326, 43327, 43329, 43330, 43332, 43333, 43337, 43339, 43340, 43346, 43350, 43352, 43355, 43371, 43372, 43381, 43407, 43423, 43425, 43427, 43430, 43433, 43435, 43438, 43443, 43447, 43459, 43467, 43477, 43481, 43483, 43493, 43499, 43501, 43505, 43516, 43524, 43526, 43530, 43532, 43538, 43544, 43552, 43556, 43560, 43567, 43569, 43579, 43581, 43586, 43589, 43591, 43593, 43595, 43598, 43603, 43609, 43632, 43637, 43646, 43650, 43652, 43655, 43658, 43667, 43673, 43685, 43692, 43714, 43735, 43742, 43745, 43769, 43778, 43783, 43785, 43794, 43800, 43811, 43817, 43823, 43828, 43846, 43853, 43855, 43862, 43865, 43867, 43875, 43882, 43885, 43895, 43904, 43912, 43913, 43914, 43919, 43927, 43945, 43946, 43956, 43957, 43968, 43977, 43981, 43982, 43987, 44008, 44011, 44013, 44023, 44028, 44034, 44040, 44065, 44069, 44073, 44079, 44118, 44122, 44124, 44128, 44130, 44132, 44136, 44148, 44152, 44156, 44158, 44160, 44162, 44169, 44173, 44183, 44185, 44189, 44191, 44193, 44195, 44199, 44201, 44203, 44205, 44209, 44211, 44213, 44215, 44217, 44220, 44222, 44224, 44226, 44229, 44234, 44236, 44241, 44243, 44250, 44257, 44262, 44274, 44278, 44280, 44285, 44292, 44310, 44314, 44327, 44340, 44357, 44371, 44376, 44381, 44386, 44388, 44403, 44406, 44411, 44416, 44420, 44431, 44433, 44436, 44441, 44448, 44451, 44453, 44461, 44466, 44471, 44475, 44481, 44484, 44486, 44492, 44495, 44508, 44510, 44525, 44527, 44536, 44539, 44541, 44544, 44545, 44546, 44550, 44552, 44553, 44562, 44568, 44571, 44572, 44574, 44576, 44581, 44584, 44585, 44587, 44588, 44596, 44598, 44600, 44606, 44611, 44614, 44617, 44626, 44627, 44629, 44631, 44633, 44637, 44640, 44642, 44651, 44653, 44661, 44665, 44669, 44675, 44681, 44683, 44685, 44687, 44689, 44693, 44697, 44699, 44705, 44707, 44708, 44709, 44710, 44711, 44730, 44732, 44736, 44739, 44745, 44754, 44759, 44761, 44763, 44765, 44773, 44775, 44788, 44795, 44802, 44809, 44812, 44816, 44821, 44823, 44833, 44843, 44846, 44848, 44856, 44859, 44862, 44870, 44873, 44879, 44883, 44896, 44906, 44910, 44912, 44924, 44933, 44951, 44954, 44960, 44963, 44965, 44970, 44977, 44982, 44988, 44994, 45000, 45003, 45006, 45010, 45026, 45029, 45034, 45040, 45045, 45050, 45051, 45056, 45057, 45063, 45065, 45067, 45070, 45074, 45075, 45076, 45078, 45079, 45081, 45082, 45102, 45108, 45109, 45111, 45112, 45113, 45114, 45138, 45148, 45160, 45161, 45163, 45168, 45173, 45187, 45195, 45197, 45203, 45205, 45207, 45209, 45211, 45215, 45217, 45221, 45225, 45229, 45235, 45239, 45243, 45247, 45249, 45277, 45286, 45294, 45299, 45304, 45309, 45313, 45337, 45346, 45358, 45371, 45422, 45441, 45443, 45453, 45455, 45468, 45479, 45484, 45494, 45499, 45501, 45508, 45514, 45516, 45525, 45528, 45530, 45536, 45541, 45551, 45556, 45558, 45566, 45576, 45583, 45592, 45594, 45602, 45608, 45611, 45622, 45636, 45649, 45650, 45651, 45654, 45659, 45661, 45662, 45663, 45665, 45667, 45669, 45671, 45672, 45676, 45683, 45691, 45701, 45703, 45705, 45713, 45718, 45720, 45730, 45746, 45747, 45751, 45755, 45760, 45766, 45770, 45778, 45780, 45786, 45802, 45804, 45810, 45814, 45816, 45822, 45828, 45839, 45849, 45863, 45870, 45891, 45898, 45908, 45938, 45943, 45950, 45983, 46010, 46030, 46035, 46037, 46044, 46049, 46054, 46067, 46089, 46097, 46099, 46102, 46105, 46114, 46120, 46126, 46272, 46276, 46278, 46282, 46283, 46285, 46290, 46291, 46293, 46296, 46298, 46302, 46308, 46312, 46314, 46316, 46322, 46326, 46328, 46330, 46335, 46337, 46342, 46344, 46348, 46352, 46364, 46366, 46374, 46386, 46390, 46402, 46404, 46406, 46410, 46412, 46418, 46422, 46430, 46435, 46440, 46445, 46454, 46463, 46468, 46473, 46480, 46485, 46489, 46496, 46502, 46504, 46508, 46510, 46521, 46523, 46528, 46537, 46556, 46611, 46613, 46623, 46631, 46633, 46646, 46651, 46660, 46665, 46667, 46670, 46671, 46675, 46680, 46682, 46685, 46687, 46690, 46694, 46696, 46701, 46705, 46710, 46717, 46835, 46851, 46853, 46859, 46860, 46864, 46880, 46882, 46886, 46888, 46892, 46896, 46898, 46904, 46906, 46910, 46916, 46920, 46928, 46934, 46940, 46946, 46952, 46958, 46960, 46964, 46970, 46978, 46988, 47010, 47028, 47032, 47036, 47048, 47056, 47062, 47072, 47075, 47078, 47085, 47092, 47100, 47107, 47116, 47118, 47155, 47172, 47185, 47191, 47203, 47208, 47211, 47219, 47225, 47230, 47237, 47241, 47243, 47246, 47252, 47254, 47263, 47269, 47272, 47288, 47294, 47448, 47452, 47455, 47457, 47461, 47463, 47465, 47473, 47480, 47483, 47494, 47498, 47504, 47508, 47516, 47520, 47522, 47524, 47532, 47534, 47538, 47542, 47546, 47550, 47554, 47556, 47565, 47567, 47569, 47571, 47574, 47576, 47579, 47581, 47583, 47585, 47588, 47590, 47592, 47620, 47632, 47642, 47644, 47679, 47728, 47738, 47758, 47768, 47781, 47783, 47786, 47788, 47791, 47804, 47807, 47812, 47822, 47829, 47832, 47837, 47842, 47844, 47847, 47849, 47852, 47854, 47857, 47862, 47864, 47866, 47871, 47878, 47893, 47899, 47902, 47907, 47992, 47998, 48001, 48007, 48021, 48022, 48025, 48030, 48031, 48034, 48037, 48040, 48044, 48046, 48048, 48050, 48058, 48067, 48073, 48075, 48079, 48085, 48094, 48104, 48106, 48108, 48130, 48141, 48151, 48165, 48167, 48171, 48175, 48177, 48179, 48201, 48228, 48235, 48284, 48310, 48312, 48314, 48326, 48328, 48333, 48338, 48346, 48351, 48353, 48355, 48365, 48367, 48381, 48383, 48388, 48406, 48422, 48431, 48607, 48617, 48627, 48649, 48671, 48691, 48711, 48751, 48994, 49008, 49013, 49015, 49017, 49022, 49027, 49032, 49037, 49040, 49047, 49052, 49055, 49062, 49068, 49073, 49080, 49082, 49089, 49091, 49096, 49103, 49109, 49111, 49114, 49117, 49119, 49247, 49251, 49259, 49271, 49273, 49275, 49283, 49285, 49287, 49295, 49297, 49299, 49309, 49311, 49323, 49325, 49327, 49349, 49358, 49363, 49367, 49377, 49379, 49381, 49386, 49391, 49393, 49395, 49400, 49403, 49407, 49412, 49415, 49424, 49426, 49431, 49433, 49435, 49438, 49440, 49453, 49461, 49464, 49471, 49477, 49484, 49492, 49499, 49506, 49512, 49516, 49519, 49524, 49526, 49528, 49533, 49542, 49549, 49555, 49557, 49564, 49572, 49579, 49588, 49593, 49596, 49598, 49603, 49615, 49619, 49626, 49629, 49641, 49643, 49648, 49758, 49763, 49767, 49771, 49773, 49781, 49784, 49786, 49789, 49792, 49795, 49798, 49804, 49808, 49810, 49818, 49826, 49834, 49840, 49846, 49850, 49858, 49864, 49870, 49876, 49882, 49896, 49906, 49916, 49923, 49930, 49934, 49944, 49948, 49953, 49956, 49962, 49967, 49970, 49972, 49977, 49979, 49984, 49988, 49991, 49993, 49997, 50005, 50009, 50012, 50018, 50022, 50028, 50043, 50051, 50066, 50074, 50076, 50081, 50083, 50088, 50091, 50110, 50127, 50142, 50145, 50147, 50162, 50178, 50183, 50185, 50197, 50204, 50207, 50212, 50225, 50341, 50344, 50349, 50354, 50355, 50357, 50362, 50363, 50365, 50381, 50386, 50390, 50397, 50403, 50407, 50413, 50415, 50421, 50425, 50439, 50443, 50448, 50453, 50457, 50465, 50467, 50469, 50471, 50476, 50481, 50493, 50497, 50502, 50507, 50516, 50521, 50525, 50530, 50533, 50535, 50545, 50548, 50553, 50561, 50563, 50567, 50572, 50575, 50577, 50580, 50590, 50596, 50604, 50606, 50610, 50615, 50622, 50637, 50643, 50646, 50651, 50655, 50667, 50670, 50673, 50675, 50679, 50683, 50746, 50791) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: The English Merchant

Afterpiece Title: Lilliput

Performances

Mainpiece Title: The Tailors

Afterpiece Title: Lilliput

Performances

Mainpiece Title: The Tailors

Afterpiece Title: Lilliput

Performances

Mainpiece Title: The Devil Upon Two Sticks

Afterpiece Title: Lilliput

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Miss Hardcastle Actor: Miss Farren

Afterpiece Title: Midas

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Miss Hardcastle Actor: Miss Farren

Afterpiece Title: Midas

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Miss Hardcastle Actor: Miss Farren

Afterpiece Title: Midas

Performances

Mainpiece Title: The Nabob

Afterpiece Title: The Citizen

Cast
Role: Maria Actor: Miss Farren

Performances

Afterpiece Title: The Fairy Tale

Cast
Role: Oberon Actor: Miss Morris
Role: Fairies Actor: Master Harrison, Miss Twist
Role: Titania Actor: Miss P. Farren

Dance: With aPastoral Dance (incident to the [main]piece)-; End: As17770707

Performances

Mainpiece Title: Hamlet

Afterpiece Title: The Fairy Tale

Cast
Role: Oberon Actor: Miss Morris
Role: Fairies Actor: Master Harrison, Miss Twist
Role: Titania Actor: Miss P. Farren

Performances

Mainpiece Title: The Merchant Of Venice

Cast
Role: Portia Actor: Miss Barsanti

Afterpiece Title: The Fairy Tale

Cast
Role: Oberon Actor: Miss Morris
Role: Fairies Actor: Master Harrison, Miss Twist
Role: Titania Actor: Miss P. Farren

Dance: As17770618

Performances

Mainpiece Title: She Stoops To Conquer

Cast
Role: Miss Hardcastle Actor: Miss Farren

Afterpiece Title: The Fairy Tale

Cast
Role: Oberon Actor: Miss Morris
Role: Fairies Actor: Master Harrison, Miss Twist
Role: Titania Actor: Miss P. Farren

Performances

Mainpiece Title: The Advertisement; Or, A Bold Stroke For A Husband

Cast
Role: La Bronze Actor: Miss Hale
Role: Lydia Fanlove Actor: Miss Platt

Afterpiece Title: The Citizen

Cast
Role: Maria Actor: Miss Farren

Performances

Mainpiece Title: Love In A Village

Cast
Role: Lucinda Actor: Miss Hale
Role: Rosetta Actor: Miss Farren

Afterpiece Title: Miss in her Teens

Dance: I: a Country Dance [incident to the [main] piece-; End II: [a New Dance [of Demi Caractere-

Performances

Mainpiece Title: Cato

Afterpiece Title: The Citizen

Cast
Role: Maria Actor: Miss Farren

Dance: End: Dance-

Performances

Mainpiece Title: Cato

Afterpiece Title: Bon Ton; or, High Life above Stairs

Cast
Role: Miss Tittup Actor: Miss Farren

Dance: As17770814

Performances

Mainpiece Title: Love In A Village

Cast
Role: Lucinda Actor: Miss Hale
Role: Rosetta Actor: Miss Farren

Afterpiece Title: Lilliput

Dance: As17770812

Performances

Mainpiece Title: April-day

Afterpiece Title: The Citizen

Cast
Role: Maria Actor: Miss Farren

Dance: End I: a New Pastoral Dance-see17770611; End II: The Provencalle-see17770611